UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiRl+Ev+7t+Dgs3pIRyDm/9w45Uf6xmMgx3G0qSA3vw='
WHERE
key_id = 'd4a69918539a0879ab3ea2f4e94dc6ae7208f2734774673a1afe4d0a7a79b262'
AND (
token = 'qiRl+Ev+7t+Dgs3pIRyDm/9w45Uf6xmMgx3G0qSA3vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)