UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Je+rGgL9cyYxreje4gf3bTZ0ENaO55xQaoVk8wvv44U='
WHERE
key_id = 'b8e3a08af2d3604abf7a9dc008f97501842ce2bf4f80c7e201e8b634be297a3c'
AND (
token = 'Je+rGgL9cyYxreje4gf3bTZ0ENaO55xQaoVk8wvv44U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)