UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9n07ZyPSshaH5fFQghjXI+A6kDRekqRxqP8iDhjmRSs='
WHERE
key_id = 'c52e35cfde1b0ad4d1db8ace61db086a736640a52c6e4f0864aad27baf97e074'
AND (
token = '9n07ZyPSshaH5fFQghjXI+A6kDRekqRxqP8iDhjmRSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)