UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xECGl07ybM3WU+X9Ux3twCI3paZLYqsKiXfOzGO2tU='
WHERE
key_id = '4674e13be28c9cc91071d4a461962652950056e015d9b5fb9bbf8b620342c37f'
AND (
token = '7xECGl07ybM3WU+X9Ux3twCI3paZLYqsKiXfOzGO2tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)