UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WL78kEjBCdqY1ruRz/HKIPBEaBapO3bj3n5egbxn6B4='
WHERE
key_id = 'c648e06dec93fcc9746c6a37b715854d17b4d2468569ae153f4e99a3cad9febd'
AND (
token = 'WL78kEjBCdqY1ruRz/HKIPBEaBapO3bj3n5egbxn6B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)