UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j634UAxvyPgHQSVaRiwjdLebmehJ7Nl2jWmcuezJO8U='
WHERE
key_id = '7ce4781fb010ef99e39e82a6ab36a5e462d8998b81d2c8f01c561ec637a9e7a0'
AND (
token = 'j634UAxvyPgHQSVaRiwjdLebmehJ7Nl2jWmcuezJO8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)