UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVyN1OqOOuJEQ9CHUOyL/ieUG+Gkb+7k257Q0N6nTMI='
WHERE
key_id = 'f2466b89345ca9ef461825452ec26baab3a487f2c3b8789f95ce5a4ab8966a98'
AND (
token = 'zVyN1OqOOuJEQ9CHUOyL/ieUG+Gkb+7k257Q0N6nTMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)