UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '97Vf+5rKLr53qVYh/uCYE6qncZP+s/iDB+EYU14fkqg='
WHERE
key_id = '4e2311461080097403753fe95894d2a42ee26d2b52793c77fc1482151669128e'
AND (
token = '97Vf+5rKLr53qVYh/uCYE6qncZP+s/iDB+EYU14fkqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)