UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KV7P1aaQnZXoc3aPZM1/vjOTA+OPLqPUdEq8V3gDHI='
WHERE
key_id = '4f4c7545609433c4aa27c5bf4762357b4b92aba20c2184c15f41997a33a3715b'
AND (
token = '3KV7P1aaQnZXoc3aPZM1/vjOTA+OPLqPUdEq8V3gDHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)