UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJlVoQUorrCFkCuNdclwN2tn1j5RozaZGgKmcyIPfcA='
WHERE
key_id = '5487c0377578ae0185606addc33fd976fdce2fa2388ce21630294f16cf7b8a93'
AND (
token = 'KJlVoQUorrCFkCuNdclwN2tn1j5RozaZGgKmcyIPfcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)