UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRNY0K4B1M68PVjmkRO05BBrrrVlBkKhpleMNxLcPng='
WHERE
key_id = 'a482e39e6837d45e0eaa1456a93d7250a3fd3ca72657da387953dcc205c17221'
AND (
token = 'XRNY0K4B1M68PVjmkRO05BBrrrVlBkKhpleMNxLcPng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)