UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DEQ3GAMGa7uTi8PixxDPP9c8UZd7Y3mOezAgZ8OsFgs='
WHERE
key_id = '8b4a3f8fe9d0e343a47c7dc6610b6523ec6c69ea18e06ef406c267bd4ff13602'
AND (
token = 'DEQ3GAMGa7uTi8PixxDPP9c8UZd7Y3mOezAgZ8OsFgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)