UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XW9wio7gDEzvDMbUs2LDXFirSSVWOip8qJbCfYN2MU='
WHERE
key_id = 'dfecbbc9899736adb9b195840fda13f475ad4feab99a4faf6145bacbc1224c59'
AND (
token = '0XW9wio7gDEzvDMbUs2LDXFirSSVWOip8qJbCfYN2MU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)