UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kN1gkQh3aZljAJl7UNWPFxxCt2gKXi9UACTMACnB9DA='
WHERE
key_id = '630eca6cfefe0c9a68b74ec3d5d2b9ffae8cb3ed5458a1707496a33b9338ff8b'
AND (
token = 'kN1gkQh3aZljAJl7UNWPFxxCt2gKXi9UACTMACnB9DA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)