UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fPx6657LAD7upeo7xXE+BVcHce6fT58KKGW4QX/gv4E='
WHERE
key_id = 'a7a6ccdb2e5b21ecfc1bf20f6a0cf7e0eb5c7429f5a859b0ddde6eb442d6fec5'
AND (
token = 'fPx6657LAD7upeo7xXE+BVcHce6fT58KKGW4QX/gv4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)