UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHbuA69y4fz7o4XDrQxPgWxGBGdCzf65W8tEZTIfGN4='
WHERE
key_id = '4decddef43f1ecc075762d71077ac2bbbacaefe9d92fa9a02d37b00dd939aeb6'
AND (
token = 'zHbuA69y4fz7o4XDrQxPgWxGBGdCzf65W8tEZTIfGN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)