UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SZUBIRQ0q6TRv67rtiwtgVf4cu6U60rgAUmq2nBNM8o=' 
WHERE 
  key_id = '7e79918c0b4c309510ed1f8e516328a139180fd8b3cd1c379c2e9879d64a78a0' 
  AND (
    token = 'SZUBIRQ0q6TRv67rtiwtgVf4cu6U60rgAUmq2nBNM8o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023