UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HZZf9uiy94nXxqIWqrp3NZSR6X55oF6A0rXDsjk6oo='
WHERE
key_id = '0063ccd490085145b7e8eb6a4f763b96ef216985e297715bb488cc6ed8f33656'
AND (
token = '7HZZf9uiy94nXxqIWqrp3NZSR6X55oF6A0rXDsjk6oo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)