UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vp7XpxsC/aeQT63t74m59ro6egx79gcLXnibT+yIWUQ=' 
WHERE 
  key_id = 'bec4010139d81c9851da4e739bdef7f4ad1bc6df1637941937f01e2a5cc87651' 
  AND (
    token = 'Vp7XpxsC/aeQT63t74m59ro6egx79gcLXnibT+yIWUQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044