UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPdNE6uHASrUy7sGeNUZMFIFIJr66dMEqyyTKOtodJ4='
WHERE
key_id = '649c12f4b5684b60368b2499859d39b7a5b33783d6f322f063a1130b20aec1aa'
AND (
token = 'KPdNE6uHASrUy7sGeNUZMFIFIJr66dMEqyyTKOtodJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)