UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNY8I04Yta45+sS6QcdWq/R37FSGgDB7UqAieK/7AcU='
WHERE
key_id = 'd2f3fc96f092d6d24714403dd413af263b2b2f01aeb11c3aa15f68d21839d3ef'
AND (
token = 'GNY8I04Yta45+sS6QcdWq/R37FSGgDB7UqAieK/7AcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)