UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7B1NjsEwS4woglP/P5ZNudABiLT4v/VZ2YXQ+czsOmA='
WHERE
key_id = '1b5b8856c480d73e20da046a1371099e7d28a1c4a2d5749a81ff0d9a19d4bb73'
AND (
token = '7B1NjsEwS4woglP/P5ZNudABiLT4v/VZ2YXQ+czsOmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)