UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2f8TXJvZoybQYIh9wfvvm7F3hEFmjqNlpzkGSKEXHhg='
WHERE
key_id = '07cd1bdccfead8e19f79017a68d514ec63d17b2ab229ef72a88061e5c99bf1d9'
AND (
token = '2f8TXJvZoybQYIh9wfvvm7F3hEFmjqNlpzkGSKEXHhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)