UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qoVdLnXD2iOXBGub2WaoZOdNFHQl1dugvLwIgqP9n8='
WHERE
key_id = '65a52d150b5c2fa1ee88b20a149a5ebde55e5b1bc21ffcb44e596b5f5af45495'
AND (
token = '7qoVdLnXD2iOXBGub2WaoZOdNFHQl1dugvLwIgqP9n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)