UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OQZvRWT2LwPSYxTHdyJ6l70eI2TsJ2j3TxkVzN8YlD0='
WHERE
key_id = '57431c7170c925695b52fc8a333fe415bb283f75017f466783945ec65524dfa8'
AND (
token = 'OQZvRWT2LwPSYxTHdyJ6l70eI2TsJ2j3TxkVzN8YlD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)