UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QqCVA9gn02PY+y57SLWaC0TU8d+eMBEHKWibeoWBVYE='
WHERE
key_id = 'd612d366fa74d47a61d5a46b1ad67d5e7d64e52b18f330a65d80d5a38f8d42d3'
AND (
token = 'QqCVA9gn02PY+y57SLWaC0TU8d+eMBEHKWibeoWBVYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)