UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+ELzRWKoR7ZjXWO9RHu2z1m7pC1xpcpwU+9vbfW235Q=' 
WHERE 
  key_id = 'd16b6f32b66577a0247dd01341f833ebf44c8ef6bdf11932c270788dc281b55f' 
  AND (
    token = '+ELzRWKoR7ZjXWO9RHu2z1m7pC1xpcpwU+9vbfW235Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021