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