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