UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xSE7R+fGIsmn8t8eTFKdSDo1030CJcsZb5yUEwgJb8='
WHERE
key_id = '12fabff16beb814dd7d43f107f293baf08a77dabc8d7de16d447a190f6170e58'
AND (
token = '1xSE7R+fGIsmn8t8eTFKdSDo1030CJcsZb5yUEwgJb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)