UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lb8o8BunwOXjYhWi0sjS7c+4VtlZOL+ugbCItFE6o7U='
WHERE
key_id = 'ca02c6ab238b4c5d27b0e70256eea0f7ef30fee8a80c21e8a3a96d3a2e199697'
AND (
token = 'Lb8o8BunwOXjYhWi0sjS7c+4VtlZOL+ugbCItFE6o7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)