UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqCiTQewUx9YJ3wEZXedXLXDfcb5t2AuzWgBfUj8fZE='
WHERE
key_id = '469446e6f3ce663f4d72a37886d32ab5b5a42cb9ac96edbf288533f94871b444'
AND (
token = 'ZqCiTQewUx9YJ3wEZXedXLXDfcb5t2AuzWgBfUj8fZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)