UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Nabwdna61FgM4fJSPdftyLUny5R94JvxnVVr6p56Jo='
WHERE
key_id = '047e70edfb78ec2b627995322e7fc015ef017c7132a9feff190c988c9fb558af'
AND (
token = '/Nabwdna61FgM4fJSPdftyLUny5R94JvxnVVr6p56Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)