UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xZJOZiTB/HQhpGhLji+185jwgMj2HYBDKPjBnMbnBg='
WHERE
key_id = 'c48bf8a7e81cf1eaf08d0095d227b9fae67452e6c156d5627e3cb8d9997ae8f1'
AND (
token = '0xZJOZiTB/HQhpGhLji+185jwgMj2HYBDKPjBnMbnBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)