UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vh2n70VnfGrrt0Nk8VYsauqaug4v2j9RVp1175ekPDs='
WHERE
key_id = 'a9a5dff03562435629a64f3225ad87b8c5ec19e128f111991d129272c4f98c8f'
AND (
token = 'vh2n70VnfGrrt0Nk8VYsauqaug4v2j9RVp1175ekPDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)