UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mV46nAQvDe40vWTmAxjEAdD5n0t6RM1o1msMsSgVwfM='
WHERE
key_id = 'b808ac035a65686dd194ea43bf069cd27197bd47de8baaefa15111912fd75d1f'
AND (
token = 'mV46nAQvDe40vWTmAxjEAdD5n0t6RM1o1msMsSgVwfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)