UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHT6pIu8Wigvp7CD9N8wZEGZ8dlQ8oHS8GY/0O2s9TY='
WHERE
key_id = 'ec666e16ea3c92b533304cef8147dd86f4a227c2a582b979441b140d94ad8031'
AND (
token = 'FHT6pIu8Wigvp7CD9N8wZEGZ8dlQ8oHS8GY/0O2s9TY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)