UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qESrHgQiRFfpyd715L7Wgwr92ZNeMYVlAAek6BWPfPo='
WHERE
key_id = '54ec0159dc7ad851f5ffb14fabb54927f7f99e4c6370e74316c25d87297b0480'
AND (
token = 'qESrHgQiRFfpyd715L7Wgwr92ZNeMYVlAAek6BWPfPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)